/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : localhost:3306
 Source Schema         : junk

 Target Server Type    : MySQL
 Target Server Version : 80023
 File Encoding         : 65001

 Date: 21/05/2022 20:27:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='管理员表';

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES ('1', 'admin', '123');
COMMIT;

-- ----------------------------
-- Table structure for application
-- ----------------------------
DROP TABLE IF EXISTS `application`;
CREATE TABLE `application` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `rid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '居民ID',
  `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出入类型',
  `reason_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出入时间',
  `reason` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '事由',
  `approval_status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审批状态',
  `approval_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审批时间',
  `approval_person` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审批人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='出入审核表';

-- ----------------------------
-- Records of application
-- ----------------------------
BEGIN;
INSERT INTO `application` VALUES ('10705654', '19847831', '进入', '2022-04-14', '回家', '02', '2022-04-14', 'lisi');
INSERT INTO `application` VALUES ('10973491', '10923491', '外出', '2021-10-29', '看望家人外出', '02', '2021-10-31', 'lisi');
INSERT INTO `application` VALUES ('12454199', '11207021', '外出', '2021-11-01', '外出工作', '02', '2021-10-31', 'mtycode');
INSERT INTO `application` VALUES ('13587807', '10576151', '进入', '2022-04-18', '回家\n', '02', '2022-04-18', 'lisi');
INSERT INTO `application` VALUES ('14581419', '19892526', '外出', '2022-03-21', '必须在', '02', '2022-03-21', 'lisi');
INSERT INTO `application` VALUES ('16942834', '10576151', '外出', '2022-04-20', '外出探亲', '01', NULL, NULL);
INSERT INTO `application` VALUES ('17702136', '10576151', '进入', '2022-04-14', '回家', '02', '2022-04-17', 'lisi');
INSERT INTO `application` VALUES ('18994103', '10576151', '外出', '2021-10-15', '工作外出', '02', '2021-10-28', 'mtycode');
COMMIT;

-- ----------------------------
-- Table structure for detection
-- ----------------------------
DROP TABLE IF EXISTS `detection`;
CREATE TABLE `detection` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `rid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '居民ID',
  `time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测日期',
  `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测地点',
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '检测状态',
  `report` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '核酸报告电子版',
  `endTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '截至时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='核酸检测表';

-- ----------------------------
-- Records of detection
-- ----------------------------
BEGIN;
INSERT INTO `detection` VALUES ('10091232', '18555916', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('10110510', '18555916', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('10277282', '13867940', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('10282380', '10576151', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('10305332', '1617371', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('10511171', '15242149', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('10548707', '16446071', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('10567981', '18555916', NULL, NULL, '01', NULL, '2021-11-01');
INSERT INTO `detection` VALUES ('10589465', '16122271', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('10610815', '14417132', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('10610949', '10923491', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('10617467', '16116071', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('10746420', '10923491', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('10790741', '16116071', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('11025217', '16122271', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('11047248', '16122271', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('11157477', '16176071', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('11209494', '16176071', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('11353643', '16446071', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('11455205', '18555916', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('11552343', '19847831', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('11573299', '13867940', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('11603453', '16116071', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('11646729', '1617371', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('11845988', '1617371', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('11949612', '19775979', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('12017382', '16122271', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('12096740', '15224952', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('12205447', '19892526', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('12274582', '1617371', NULL, NULL, '01', NULL, '2021-11-10');
INSERT INTO `detection` VALUES ('12388309', '19892526', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('12524109', '14417132', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('12578972', '15242149', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('12832009', '16233071', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('12855893', '19775979', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('12923816', '16233071', NULL, NULL, '01', NULL, '2021-11-04');
INSERT INTO `detection` VALUES ('12965414', '10576151', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('13091642', '14417132', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('13096571', '15242149', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('13102266', '14417132', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('13131556', '13867940', NULL, NULL, '01', NULL, '2021-11-05');
INSERT INTO `detection` VALUES ('13227104', '16233071', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('13249479', '16233071', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('13280089', '18555916', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('13391955', '14417132', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('13437598', '16122271', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('13495635', '14417132', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('13559764', '16122271', NULL, NULL, '01', NULL, '2021-11-05');
INSERT INTO `detection` VALUES ('13587927', '16446071', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('13648146', '19775979', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('13685564', '10923491', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('13732808', '19775979', NULL, NULL, '01', NULL, '2021-11-06');
INSERT INTO `detection` VALUES ('13794408', '19847831', '2022-04-15', '北操', '02', NULL, '2022-04-15');
INSERT INTO `detection` VALUES ('13830674', '15224952', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('13870429', '15242149', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('14004201', '16233071', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('14074670', '19892526', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('14210416', '16446071', NULL, NULL, '01', NULL, '2021-11-07');
INSERT INTO `detection` VALUES ('14294071', '19775979', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('14557893', '18555916', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('14562194', '15224952', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('14891861', '10576151', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('14911994', '16446071', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('14956741', '1617371', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('15105318', '16122271', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('15203289', '19892526', '2022-03-21', '发射点发生', '02', '20220321192413_111.jpg', '2022-03-21');
INSERT INTO `detection` VALUES ('15248467', '16233071', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('15398728', '15224952', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('15668464', '19892526', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('15695190', '16116071', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('15695315', '1617371', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('15813161', '16176071', NULL, NULL, '01', NULL, '2021-11-04');
INSERT INTO `detection` VALUES ('15845108', '16446071', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('15918283', '14417132', NULL, NULL, '01', NULL, '2021-11-04');
INSERT INTO `detection` VALUES ('15989724', '10576151', '2022-04-20', '北操', '02', NULL, '2022-04-20');
INSERT INTO `detection` VALUES ('16129158', '16176071', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('16307931', '16116071', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('16376193', '16116071', NULL, NULL, '01', NULL, '2021-11-05');
INSERT INTO `detection` VALUES ('16458997', '19775979', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('16512649', '18555916', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('16638891', '16176071', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('16769077', '19775979', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('16783866', '10923491', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('16880958', '10923491', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('16904492', '19775979', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('17084248', '16176071', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('17137426', '10576151', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('17151312', '19892526', '2022-03-21', '鲁东大学\n', '02', '20220321192449_微信图片_20211229080152.jpg', '2022-03-21');
INSERT INTO `detection` VALUES ('17247218', '15224952', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('17339374', '13867940', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('17430770', '10576151', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('17479938', '15242149', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('17739116', '10923491', NULL, NULL, '01', NULL, '2021-11-05');
INSERT INTO `detection` VALUES ('17952116', '16233071', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('18001064', '15242149', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('18019407', '18555916', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('18135894', '19892526', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('18151515', '13867940', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('18159072', '16176071', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('18211475', '11207021', '2021-11-01', '华夏社区检测点', '02', '20211031232144_123.pdf', '2021-11-03');
INSERT INTO `detection` VALUES ('18241543', '10576151', '2022-04-15', '北操', '02', NULL, '2022-04-15');
INSERT INTO `detection` VALUES ('18525604', '1617371', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('18538195', '16446071', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('18637784', '10576151', '2022-04-18', '123456', '02', NULL, '2022-04-18');
INSERT INTO `detection` VALUES ('18732855', '16233071', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('18746347', '10576151', '2022-04-13', '北操', '02', NULL, '2022-04-13');
INSERT INTO `detection` VALUES ('18796029', '16116071', NULL, NULL, '01', NULL, '2022-03-24');
INSERT INTO `detection` VALUES ('18856674', '16176071', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('19139732', '1617371', NULL, NULL, '01', NULL, '2022-04-17');
INSERT INTO `detection` VALUES ('19238787', '14417132', NULL, NULL, '01', NULL, '2022-03-17');
INSERT INTO `detection` VALUES ('19323347', '10576151', '2022-04-12', '北北操', '02', NULL, '2022-04-12');
INSERT INTO `detection` VALUES ('19386563', '16122271', NULL, NULL, '01', NULL, '2021-11-03');
INSERT INTO `detection` VALUES ('19391196', '16116071', NULL, NULL, '01', NULL, '2022-03-31');
INSERT INTO `detection` VALUES ('19658066', '10576151', NULL, NULL, '01', NULL, '2022-03-23');
INSERT INTO `detection` VALUES ('19716333', '15242149', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('19843089', '10576151', '2021-10-25', '第一人民医院', '02', NULL, '2021-11-05');
INSERT INTO `detection` VALUES ('19899483', '15242149', NULL, NULL, '01', NULL, '2021-11-02');
INSERT INTO `detection` VALUES ('19941643', '16446071', NULL, NULL, '01', NULL, '2022-03-07');
INSERT INTO `detection` VALUES ('19945425', '10576151', NULL, NULL, '01', '20220420201619_1.png', '2021-11-03');
INSERT INTO `detection` VALUES ('19978416', '13867940', NULL, NULL, '01', NULL, '2022-03-17');
COMMIT;

-- ----------------------------
-- Table structure for evaluate
-- ----------------------------
DROP TABLE IF EXISTS `evaluate`;
CREATE TABLE `evaluate` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '回收员姓名',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '评价内容',
  `userid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '评价用户',
  `createtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of evaluate
-- ----------------------------
BEGIN;
INSERT INTO `evaluate` VALUES (1, '罗曼（ROAMAN）电动牙刷E7', NULL, NULL, '2022-05-21 19:12:02');
INSERT INTO `evaluate` VALUES (2, 'zs', 'rrr', NULL, '2022-05-21 19:12:56');
INSERT INTO `evaluate` VALUES (3, '张三', '服务很好，下次还选择他', NULL, '2022-05-21 20:18:40');
COMMIT;

-- ----------------------------
-- Table structure for inform
-- ----------------------------
DROP TABLE IF EXISTS `inform`;
CREATE TABLE `inform` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '举报人姓名',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '举报人电话',
  `content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '举报内容',
  `time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '举报时间',
  `result` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '处理结果',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='举报表';

-- ----------------------------
-- Records of inform
-- ----------------------------
BEGIN;
INSERT INTO `inform` VALUES ('1', '10576151', '15232323232', '隔壁住户有从高风险地区回来人员', '2021-02-02', '123');
INSERT INTO `inform` VALUES ('10003655', '10576151', '15263232324', '123456', '2022-04-17', '已上报');
INSERT INTO `inform` VALUES ('11616755', '10576151', '15263232324', 'dasasdasdsa', '2022-04-21', NULL);
INSERT INTO `inform` VALUES ('13426972', '10576151', '15263232324', '举报', '2022-03-12', '已经上报\n');
INSERT INTO `inform` VALUES ('13426973', '10576151', '15263232324', '举报', '2022-03-12', '已经上报\n');
INSERT INTO `inform` VALUES ('19026177', '11207021', NULL, '隔壁1202家人从高风险地区归来，未隔离', '2021-10-31', '已知晓');
COMMIT;

-- ----------------------------
-- Table structure for junk_orders
-- ----------------------------
DROP TABLE IF EXISTS `junk_orders`;
CREATE TABLE `junk_orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `specification` decimal(10,2) DEFAULT NULL,
  `unitprice` decimal(10,2) DEFAULT NULL,
  `totalprice` decimal(10,2) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of junk_orders
-- ----------------------------
BEGIN;
INSERT INTO `junk_orders` VALUES (1, '塑料瓶', '废纺织品/废皮革', 14.00, 1.30, 18.20, '2022-05-21 15:29:50');
INSERT INTO `junk_orders` VALUES (2, '榴莲糖', '废金属', 14.00, 2.00, 28.00, '2022-05-21 15:38:25');
INSERT INTO `junk_orders` VALUES (3, '天津麻花', '废塑料', 15.00, 13.00, 195.00, '2022-05-21 20:09:14');
INSERT INTO `junk_orders` VALUES (4, '废铁', '废金属', 100.00, 15.00, 1500.00, '2022-05-21 20:16:35');
COMMIT;

-- ----------------------------
-- Table structure for manager
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='社区管理员表';

-- ----------------------------
-- Records of manager
-- ----------------------------
BEGIN;
INSERT INTO `manager` VALUES ('10320987', 'zhangsan', '123456', '15252632111');
INSERT INTO `manager` VALUES ('13857369', 'wangwu', '123456', '18569632142');
INSERT INTO `manager` VALUES ('18206640', 'lisi', '123456', '15263236328');
INSERT INTO `manager` VALUES ('18206656', 'huangtou', '123456', '15689928845');
COMMIT;

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公告标题',
  `content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '内容',
  `time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='公告表';

-- ----------------------------
-- Records of notice
-- ----------------------------
BEGIN;
INSERT INTO `notice` VALUES ('13131080', '核酸检测通知', '11月1日开始第一轮核酸', '2021-10-27');
INSERT INTO `notice` VALUES ('14738602', '全体核酸检测', '11月3日之前必须做完第二轮核酸检测', '2021-10-31');
COMMIT;

-- ----------------------------
-- Table structure for receipt
-- ----------------------------
DROP TABLE IF EXISTS `receipt`;
CREATE TABLE `receipt` (
  `id` int NOT NULL AUTO_INCREMENT,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `booktime` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预约时间',
  `createtime` datetime DEFAULT NULL COMMENT '创建时间',
  `userid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of receipt
-- ----------------------------
BEGIN;
INSERT INTO `receipt` VALUES (1, 'ads', '2022-05-21', '2022-05-21 19:59:53', '10576151');
INSERT INTO `receipt` VALUES (2, '北京', '2022-05-20', '2022-05-21 20:19:13', '10576151');
COMMIT;

-- ----------------------------
-- Table structure for report
-- ----------------------------
DROP TABLE IF EXISTS `report`;
CREATE TABLE `report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `rubbish_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `userid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of report
-- ----------------------------
BEGIN;
INSERT INTO `report` VALUES (2, '王五', '电视机', '价格差距太大', '2022-05-21 16:22:30', NULL);
INSERT INTO `report` VALUES (3, '张三', '手机', '价格过低', '2022-05-21 20:18:12', '10576151');
COMMIT;

-- ----------------------------
-- Table structure for resident
-- ----------------------------
DROP TABLE IF EXISTS `resident`;
CREATE TABLE `resident` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `realname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
  `idcard` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '身份证号',
  `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '目前住址',
  `community` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所属社区',
  `place` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '户籍所在地',
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '居民状态',
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '居民类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='居民表';

-- ----------------------------
-- Records of resident
-- ----------------------------
BEGIN;
INSERT INTO `resident` VALUES ('10576151', 'liuyu', '123456', '刘雨', '女', '15263232324', '412363199002012222', '山东省烟台市芝罘区白石社区3号楼1单元201', '白石社区', '山东省烟台市芝罘区白石社区3号楼1单元202', '02', '01');
INSERT INTO `resident` VALUES ('12391210', 'didi', '123456', '小红', '女', '15628890081', '371482199810284212', '山东省烟台市芝罘区鲁东大学', '幸福社区', '山东省烟台市芝罘区鲁东大学', '01', '01');
INSERT INTO `resident` VALUES ('14417132', 'guoxu', '123456', '郭旭', '男', '18523632323', '410202199002032222', '山东省烟台市芝罘区黄务社区2号楼2单元901', '黄务社区', '山东省烟台市芝罘区黄务社区2号楼2单元901', '01', '01');
INSERT INTO `resident` VALUES ('14790475', '万帅', '123456', NULL, NULL, '15628890025', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `resident` VALUES ('15242149', 'zhangyang', '123456', '张扬', '男', '15896563232', '152362199605071258', '山东省烟台市芝罘区黄务社区9号楼3单元1903', '黄务社区', '山东省烟台市芝罘区黄务社区9号楼3单元1903', '01', '01');
INSERT INTO `resident` VALUES ('16116071', 'liuyang', '123456', '刘洋', '男', '13248745634', '153612199302071914', '山东省烟台市芝罘区白石社区6号楼2单元1301', '白石社区', '山东省烟台市芝罘区白石社区6号楼2单元1301', '02', '02');
INSERT INTO `resident` VALUES ('16122271', 'mayu', '123456', '马雨', '女', '18268745698', '158563199502300102', '山东省烟台市芝罘区幸福社区2号楼3单元1502', '幸福社区', '山东省烟台市芝罘区幸福社区2号楼3单元1502', '01', '02');
INSERT INTO `resident` VALUES ('1617371', 'zhaohan', '123456', '赵晗', '女', '18068741634', '695321199607040589', '山东省烟台市芝罘区黄务社区3号楼2单元301', '黄务社区', '山东省烟台市芝罘区黄务社区3号楼2单元301', '01', '02');
INSERT INTO `resident` VALUES ('16176071', 'guoyu', '123456', '郭玉', '女', '15268745634', '153612199303021214', '山东省烟台市芝罘区幸福社区2号楼1单元1201', '幸福社区', '山东省烟台市芝罘区幸福社区2号楼1单元1201', '01', '02');
INSERT INTO `resident` VALUES ('16233071', 'guoxiao', '123456', '郭萧', '男', '13668748874', '410203198502301478', '山东省烟台市芝罘区幸福社区2号楼1单元1001', '幸福社区', '山东省烟台市芝罘区幸福社区2号楼1单元1001', '01', '02');
INSERT INTO `resident` VALUES ('16446071', 'wangyuyan', '123456', '王语嫣', '女', '15444785634', '856321199102302589', '山东省烟台市芝罘区黄务社区3号楼1单元1201', '黄务社区', '山东省烟台市芝罘区黄务社区3号楼1单元1201', '01', '02');
INSERT INTO `resident` VALUES ('18555916', 'zhaokai', '123456', '赵凯', '男', '13962325326', '596321198602094758', '山东省烟台市芝罘区白石社区3号楼1单元501', '白石社区', '山东省烟台市芝罘区白石社区3号楼1单元501', '01', '02');
INSERT INTO `resident` VALUES ('19775979', 'xuyang', '123456', '徐阳', '男', '18524121212', '125963199302028596', '山东省烟台市芝罘区幸福社区1号楼1单元1301', '幸福社区', '山东省烟台市芝罘区幸福社区1号楼1单元1301', '01', '01');
INSERT INTO `resident` VALUES ('19847831', 'wangzhengxu', '123456', '王正旭', '男', '15628890081', '371482199810284212', '山东省烟台市芝罘区鲁东大学北区', '幸福社区', '山东省烟台市芝罘区鲁东大学北区', '01', '02');
COMMIT;

-- ----------------------------
-- Table structure for rubbish
-- ----------------------------
DROP TABLE IF EXISTS `rubbish`;
CREATE TABLE `rubbish` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of rubbish
-- ----------------------------
BEGIN;
INSERT INTO `rubbish` VALUES (2, '021', '废纺织品/废皮革', 1.35, '2022-05-20 21:04:42');
INSERT INTO `rubbish` VALUES (3, '031', '废塑料', 13.00, '2022-05-21 20:07:37');
INSERT INTO `rubbish` VALUES (4, '041', '废金属', 15.00, '2022-05-21 20:14:47');
COMMIT;

-- ----------------------------
-- Table structure for visitor
-- ----------------------------
DROP TABLE IF EXISTS `visitor`;
CREATE TABLE `visitor` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
  `idcard` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '身份证号',
  `temperature` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '体温',
  `reason` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '事由',
  `time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来访时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='访客表';

-- ----------------------------
-- Records of visitor
-- ----------------------------
BEGIN;
INSERT INTO `visitor` VALUES ('10893978', '郭珊', '15263236323', '415263199002041236', '36.3', '看望家人', '2021-10-27');
INSERT INTO `visitor` VALUES ('11873386', '赵鹏', '18745615896', '256314198402071596', '36', '送餐', '2021-10-20');
INSERT INTO `visitor` VALUES ('15043971', '张晓燕', '15263236987', '415263199005052326', '36.2', '探望亲人', '2021-10-31');
COMMIT;

-- ----------------------------
-- Table structure for wuzi
-- ----------------------------
DROP TABLE IF EXISTS `wuzi`;
CREATE TABLE `wuzi` (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '居民姓名',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '居民电话',
  `content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '居民需求物资',
  `time` datetime DEFAULT NULL COMMENT '申请时间',
  `result` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '处理结果',
  `goods` varchar(255) DEFAULT NULL COMMENT '物资名称',
  `count` decimal(8,2) DEFAULT NULL COMMENT '物资数量',
  `community` varchar(255) DEFAULT NULL COMMENT '社区名称',
  `typeid` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='举报表';

-- ----------------------------
-- Records of wuzi
-- ----------------------------
BEGIN;
INSERT INTO `wuzi` VALUES ('11346503', '榴莲糖', NULL, NULL, '2022-05-03 07:00:29', NULL, NULL, 110.00, '白石社区', 3);
INSERT INTO `wuzi` VALUES ('15466502', '天津麻花', NULL, NULL, '2022-05-02 18:09:43', NULL, NULL, 122.00, '白石社区', 3);
INSERT INTO `wuzi` VALUES ('15503122', '南瓜', NULL, NULL, '2022-04-30 20:40:06', NULL, NULL, 651.00, '白石社区', 3);
INSERT INTO `wuzi` VALUES ('15828853', '医用口罩', NULL, NULL, '2022-04-30 18:44:13', NULL, NULL, 100.00, '奇山社区', 1);
INSERT INTO `wuzi` VALUES ('16051669', '花椒锅巴', NULL, NULL, '2022-05-02 18:06:02', NULL, NULL, 23331.00, '白石社区', 3);
INSERT INTO `wuzi` VALUES ('17441584', '医用口罩', NULL, NULL, '2022-05-02 16:49:37', NULL, NULL, 10000.00, '白石社区', 1);
INSERT INTO `wuzi` VALUES ('17679762', '猪肉', NULL, NULL, '2022-05-02 18:02:16', NULL, NULL, 1222.00, '白石社区', 3);
INSERT INTO `wuzi` VALUES ('17862639', '10576151', '15263232324', '我需要两斤苹果', '2022-04-08 00:00:00', '已购买，请稍等，若有其他要求联系：15628890081\n', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for wuzitype
-- ----------------------------
DROP TABLE IF EXISTS `wuzitype`;
CREATE TABLE `wuzitype` (
  `tid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `createtime` datetime DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of wuzitype
-- ----------------------------
BEGIN;
INSERT INTO `wuzitype` VALUES (1, '防疫物资', '2022-05-02 15:55:41');
INSERT INTO `wuzitype` VALUES (3, '生活物资', '2022-05-02 16:42:55');
INSERT INTO `wuzitype` VALUES (5, '饮料', '2022-05-03 07:01:28');
INSERT INTO `wuzitype` VALUES (6, '饮料', '2022-05-03 07:02:13');
INSERT INTO `wuzitype` VALUES (7, '日用品', '2022-05-03 07:03:02');
INSERT INTO `wuzitype` VALUES (8, '鞋帽', '2022-05-03 07:09:07');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
